﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'UpdateEstadoBien')
	BEGIN
		DROP  Procedure  UpdateEstadoBien
	END

GO

CREATE Procedure UpdateEstadoBien
	@idBien int,
	@estado int
AS

UPDATE Bien SET Estado = @estado WHERE IdBien = @idBien

GO


GRANT EXEC ON UpdateEstadoBien TO PUBLIC

GO


